﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using JUtil;
using System.Data;

public partial class DataList_demoDataList : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        dl.DataSource = GetDataSource();
        dl.DataBind();
    }

    private DataTable GetDataSource()
    {
        IDatabase db = DbUtil.GetDbObject(new DbConnectionConfig
        {
            DbProvider = DbProvider.Oracle,
            ConnectionString = "Data Source=tppddb;User ID=tpdbuser;Password=tpdbuser;"
        });
        DataTable dt = db.SelectSQL("SELECT TPMUSER FROM TPM_MEMBER");
        return dt;
    }
}
